home *** CD-ROM | disk | FTP | other *** search
/ The Original Shareware 1.1 / The Original Shareware (WeMake CDs)(Volume 1.1)(CDs, Inc)(1993).iso / 14 / lotuswks.zip / WSFF2A.TXT < prev    next >
Text File  |  1986-07-29  |  4KB  |  153 lines
  1.  
  2.  
  3. ADDENDUM to WORKSHEET FILE FORMAT Document (2-19-85):
  4.  
  5.  
  6. The following supplements the discussion of the FORMULA record
  7. type in the Worksheet File Format document.
  8. __________________________________________________________________________
  9.  
  10.  
  11.     Formula Record Type
  12.  
  13.           byte 0 = format
  14.                   byte 1 & 2 = column 
  15.                   byte 3 & 4 = row
  16.                   byte 5-12 = formula numeric value (IEEE long real)
  17.                   byte 13 & 14 = formula size (bytes)
  18.                   byte 15 & above = formula code, compiled Reverse-Polish
  19.                                     Internal Notation; max of 2048 bytes 
  20.  
  21.         Opcode     Explanation
  22.         ------     ------------
  23.  
  24.         0          push constant...followed by 8 byte #
  25.         1          push variable...followed by 4 byte column,row...a
  26.                       relative coordinate has its most significant bit set
  27.         2          push range...followed by 8 byte begin/end column,row
  28.         3          end of formula
  29.         4          parentheses
  30.         5          integer constant...followed by 2 byte integer
  31.         6          push string...followed by null terminated string
  32.         7          unused
  33.         8          unary -
  34.         9          binary +
  35.        10          binary -
  36.  
  37.        11          *
  38.        12          /
  39.        13          ^
  40.        14          =
  41.        15          <>
  42.        16          <=
  43.        17          >=
  44.        18          <
  45.        19          >
  46.        20          #AND#
  47.  
  48.        21          #OR#
  49.        22          #NOT#
  50.        23          unary +
  51.        24          &
  52.        25..30      unused
  53.  
  54.        31          @na
  55.        32          @err
  56.        33          @abs
  57.        34          @int
  58.        35          @sqrt
  59.        36          @log
  60.        37          @ln
  61.        38          @pi
  62.        39          @sin
  63.        40          @cos
  64.  
  65.        41          @tan
  66.        42          @atan2
  67.        43          @atan
  68.        44          @asin
  69.        45          @acos
  70.        46          @exp
  71.        47          @mod
  72.        48          @sel
  73.        49          @isna
  74.        50          @iserr
  75.  
  76.        51          @false
  77.        52          @true
  78.        53          @rand
  79.        54          @date
  80.        55          @now
  81.        56          @pmt
  82.        57          @pv
  83.        58          @fv
  84.        59          @if
  85.        60          @day
  86.  
  87.        61          @month
  88.        62          @year
  89.        63          @round
  90.        64          @time
  91.        65          @hour
  92.        66          @minute
  93.        67          @second
  94.        68          @isnumber
  95.        69          @isstring
  96.        70          @length
  97.  
  98.        71          @value
  99.        72          @fixed
  100.        73          @mid
  101.        74          @chr
  102.        75          @ascii
  103.        76          @find
  104.        77          @datevalue
  105.        78          @timevalue
  106.        79          @cell pointer
  107.        80          @sum..followed by 1 byte >>> # of args
  108.  
  109.        81          @avg..same as above
  110.        82          @cnt.. "    "   "
  111.        83          @min.. "    "   "
  112.        84          @max.. "    "   "
  113.        85          @vlookup
  114.        86          @npv
  115.        87          @var
  116.        88          @std
  117.        89          @irr
  118.        90          @hlookup
  119.  
  120.        91          @dsum
  121.        92          @davg
  122.        93          @dcnt
  123.        94          @dmin
  124.        95          @dmax
  125.        96          @dvar
  126.        97          @dstd
  127.        98          @index
  128.        99          @cols
  129.       100          @rows
  130.  
  131.       101          @repeat
  132.       102          @upper
  133.       103          @lower
  134.       104          @left
  135.       105          @right
  136.       106          @replace
  137.       107          @proper
  138.       108          @cell
  139.       109          @trim
  140.       110          @clean
  141.  
  142.       111          @s
  143.       112          @v
  144.       113          @streq
  145.       114          @call
  146.       115          @indirect
  147.  
  148.  
  149. -- end of list --
  150.  
  151.  
  152.  
  153.